PMON failed to acquire latch, see PMON dump | 您所在的位置:网站首页 › she failed to acquire › PMON failed to acquire latch, see PMON dump |
前几天,一台Oracle数据库(Oracle Database 10g Release 10.2.0.4.0 - 64bit Production)监控出现"PMON failed to acquire latch, see PMON dump"错误,连接数据库出现短暂异常,告警日志中具体错误如下所示: Tue Dec 20 09:13:16 2016PMON failed to acquire latch, see PMON dumpTue Dec 20 09:14:16 2016PMON failed to acquire latch, see PMON dumpTue Dec 20 09:15:55 2016PMON failed to acquire latch, see PMON dumpTue Dec 20 09:17:15 2016PMON failed to acquire latch, see PMON dumpTue Dec 20 09:17:24 2016WARNING: inbound connection timed out (ORA-3136)Tue Dec 20 09:18:23 2016PMON failed to acquire latch, see PMON dumpTue Dec 20 09:19:24 2016PMON failed to acquire latch, see PMON dump
在生成的epps_pmon_4988.trc 跟踪文件里面,发现有些详细信息,你会发现PMON进程不能获取'Child shared pool' latch,它被一个pid = 19 ospid=5022的进程给阻塞了。而ospid这个进程是一个Dispatcher的进程。 *** 2016-12-20 09:14:16.575PMON unable to acquire latch 600edfa8 Child shared pool level=7 child#=1 Location from where latch is held: kghfrunp: alloc: session dur: Context saved from call: 0 state=busy, wlstate=free waiters [orapid (seconds since: put on list, posted, alive check)]: 33 (3, 1482196555, 3) 10 (3, 1482196555, 3) 25 (3, 1482196555, 3) 13 (3, 1482196555, 3) waiter count=4 gotten 861091119 times wait, failed first 7114074 sleeps 1392223 gotten 0 times nowait, failed: 0 possible holder pid = 19 ospid=5022----------------------------------------SO: 0x40979aec8, type: 2, owner: (nil), flag: INIT/-/-/0x00 (process) Oracle pid=19, calls cur/top: (nil)/0x409c92608, flag: (80) DISPATCHER int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 0 0 236 last post received-location: kmcpdp last process to post me: 4097a64a0 106 64 last post sent: 0 0 229 last post sent-location: kmcmbf: not KMCVCFTOS last process posted by me: 4097a64a0 106 64 (latch info) wait_event=0 bits=a0 holding (efd=4) 600edfa8 Child shared pool level=7 child#=1 Location from where latch is held: kghfrunp: alloc: session dur: Context saved from call: 0 state=busy, wlstate=free waiters [orapid (seconds since: put on list, posted, alive check)]: 33 (3, 1482196555, 3) 10 (3, 1482196555, 3) 25 (3, 1482196555, 3) 13 (3, 1482196555, 3) waiter count=4 holding (efd=4) 3fff78210 Child library cache level=5 child#=2 Location from where latch is held: kghfrunp: clatch: wait: Context saved from call: 0 state=busy, wlstate=free waiters [orapid (seconds since: put on list, posted, alive check)]: 15 (3, 1482196555, 3) 17 (3, 1482196555, 3) 12 (3, 1482196555, 3) waiter count=3 Process Group: DEFAULT, pseudo proc: 0x4098bc190 O/S info: user: oracle, term: UNKNOWN, ospid: 5022 OSD pid info: Unix process pid: 5022, image: [email protected] (D007) Short stack dump: ksdxfstk()+32 |
CopyRight 2018-2019 实验室设备网 版权所有 |